Nicola Sturgeon's hopes of keeping Scotland in EU hit by Francois Hollande and Spanish PM Rajoy