The Duke of Sussex has received a full apology and substantial damages from the publisher of The Sun for "serious intrusion" into his private life.