Scotland losing out on oil decommissioning 'because it doesn't fit SNP's political narrative'