Sophie, Duchess of Edinburgh, steals the show at the Order of the Thistle ceremony in St Giles Cathedral with her stunning pink dress.