Prince Andrew to give up all his titles and honours