Any future bid to host the Olympic and Paralympic Games on home soil must take place in the north of England, mayors have argued.