The government will support "hundreds" of new licences off the coast of Scotland, while new plans for a "clean" carbon capture industry could support up to 50,000 new roles, according to Downing Street.