A service of thanksgiving has been held for author Dame Jilly Cooper at Southwark Cathedral. Her longtime friend the Queen was among those who attended.