Nicola Sturgeon resigns as first minister