Council split between Reform UK, Greens, Tories, Labour, Lib Dems and Independents in chaotic outcome for city