Sophie, who was a favourite with the late monarch, is known for her down-to-earth nature and was viewed by the Queen as The Firm's safest pair of hands