South West urged to learn lessons from Aberdeen and North East Scotland’s transition away from fossil fuels