An SNP MSP has broken with his party, calling for the Jackdaw and Rosebank oil fields to be approved by the UK Government.