World’s most senior psychiatrist comes out and says profession should apologise to gay people