The late Queen asked Nicola Sturgeon for 'gossip' about the Alex Salmond sex scandal, the former first minister has revealed in her memoirs.