Member of the British royal family who received a formal apology and substantial damages from The Sun newspaper for serious intrusion into his private life