Saint Petersburg’s most famous thoroughfare is a joy for travellers looking for a taste of the city’s opulent founding spirit