SNP Government talked down oil and gas industry by failing to back up spurious claim made by Humza Yousaf