The city’s pubs and bars might have shut their doors shortly after Scotland’s 0-0 draw with England, but a chaotic day of celebration will live long in the memory