Turkey's main opposition party has retained its control over key cities and made huge gains in local elections, in a major upset to President Recep Tayyip Erdogan.