Sophie, the Countess of Wessex, was left "humiliated" after she was caught up in a scandal, but she was able to bounce back ...