The first minister has told Holyrood fossil fuels will be required "for some years to come".