Cities around the world are coming to the same conclusion: they’d be better off with far fewer cars. So what’s behind this seismic shift in our urban lifestyles? Stephen Moss investigates