The survey found most people in Scotland want to see a mix of renewable and fossil fuel production.