Africa’s biggest cities set for a shake-up, with Cape Town and Joburg slipping by 2050