Prince Andrew to give up all his titles and honours, including Duke of York