What is fairly likely is that the-greater-fool will apply. Some people won't discount the risk properly and you are therefore bidding against people who overvalue the asset.
It's not uncommon with really expensive houses for a new owner to have it demolished so he can build the house he wants instead; the value is in having permission to have a house on that land, and an earthquake won't take that away (unless it's a really huge earthquake that outright destroys land or makes everyone leave forever).
If that type of earthquake hit SF or Tokyo, I don't really know how much earthquake-proofing will matter?
Stuff like this seems pretty scary for big buildings: https://commons.m.wikimedia.org/wiki/File:Liquefaction_at_Ni...
It would be interesting if someone with expertise was able to offer better insight. Like the above picture illustrates, I don't know if at some point it matters anymore how well the building or foundation is built if the ground is liquified, or moves too much.
Buying a unit in a highrise in SF never really made sense to me.