Sophie is below Camilla in both Official and Private Orders of Precedence, and that's been the case ever since Camilla married Prince Charles in 2005.
In the Official Order of Precedence, Camilla (as wife of the Prince of Wales) is the second Lady in the Kingdom after the Queen herself.
In the Private Order of Precedence, Camilla is below only Princesses by blood - Anne, Beatrice, Eugenie, Louise (*) and Alexandra, but still ahead of Sophie.
The Official Order of Precedence
- Queen Elizabeth (The Queen)
- The Duchess of Cornwall (the wife of the Sovereign's eldest son)
- The Countess of Wessex (the wife of the Sovereign's younger son)
- The Princess Royal (the Sovereign's daughter)
- The Duchess of Cambridge (the wife of the Sovereign's grandson)
- Autumn Phillips (the wife of the Sovereign's grandson)
- Princess Beatrice (the Sovereign's granddaughter)
- Princess Eugenie (the Sovereign's granddaughter)
- Lady Louise (the Sovereign's granddaughter)
- Zara Phillips (the Sovereign's granddaughter)
- Lady Serena Stanhope (Wife of the Sovereign's nephew)
- Lady Sarah Chatto (Sovereign's niece)
- Birgitte, Duchess of Gloucester (Wife of the Sovereign's cousin)
- Katharine, Duchess of Kent (Wife of the Sovereign's cousin)
- Princess Michael of Kent (Wife of the Sovereign's cousin)
- Princess Alexandra, The Honourable Lady Ogilvy (Sovereign's cousin)
The Private Order of Precedence
- Queen Elizabeth (the Sovereign)
- Princess Anne (British Princess by birth)
- Princess Beatrice (British Princess by birth)
- Princess Eugenie (British Princess by birth)
- Lady Louise (British Princess by birth) *
- Princess Alexandra (British Princess by birth)
- Camilla, The Duchess of Cornwall (British Princess by marriage)
- Sophie, The Countess of Wessex (British Princess by marriage)
- Catherine, Duchess of Cambridge (British Princess by marriage)
- Autumn Phillips
- Zara Phillips
* Assuming we accept Lady Louise is a Princess by birth (as per Letters Patent 1917), despite not using the title.