The Government has backed plans to host the Olympic and Paralympic Games in the north of England for the very first time.