Nicola Sturgeon accused of ‘abandoning’ oil and gas sector after announcing Cambo opposition