King Charles III has stripped his brother, Prince Andrew, of his remaining royal titles and honours, confirming he will henceforth be known as Andrew Mountbatten Windsor.