The chancellor has announced billions of pounds of investment in public transport in the North and Midlands - but said other departments have not got what they asked for.