The Scottish government will no longer support the unlimited recovery of oil and gas, First Minister Nicola Sturgeon has