Nicola Sturgeon hints at joining countries committed to ending oil and gas production