The Duke of Edinburgh’s life was filled with contradictions but will be remembered most for his unstinting support of the Queen.