The old mechanical meggers used about 500V, and that was it.
Essentially what you're testing has to meet a certain specification, so if that specification calls for 250V then you would need a megger that can provide that, likewise you would need a 1000V megger if the spec called for that.
But generally 500V has always been the default testing voltage.
Meggers were also good for testing EHT rectifiers, whch were commonly a huge stack of small selenium discs, and required considerable voltage to conduct in the forward direction, much more than a normal meter can supply.