After a controversial few years when she first married Prince Edward, Sophie Wessex has become one of the Queen’s most trusted confidantes.