Oil and gas workers being let down by government ‘inaction’ over jobs transition, says MSP