Increase in FDI is only ‘notable success’ of Northern Powerhouse project, says former Treasury minister O’Neill