The oil and gas industry could provide lifetime employment for a generation of Scots according to the First Minister.