Vertiginously high, excruciatingly painful, exorbitantly expensive – a new exhibition uncovers history’s most extreme footwear. Alastair Sooke takes a look.