The Duke of Edinburgh may have been the longest living Royal Consort in British history, carrying out thousands of official duties. But he was also so much more.