The author of a new book about Prince Andrew has said the royal has “no public or private future” following his hugely ...