Foreign investment grows in north of England but falls in rest of UK