Union warns £6.6bn needed now to save 30,000 Scots oil