It all comes down to the footprint of the tank or how much the weight is spread. On a second floor you can keep a stock 125 gallon with dimensions of 48x24x24 and the weight would be 156.25lbs per square foot or less than most adults standing on the floor (thats on a stand with a full flush bottom touching the floor instead of just 4 2x4 legs. a stand with just legs would exert 312.5 lbs per leg)
A larger tank would work provided the footprint spread out to allow for the increased weight of the tank without adding weight per square foot of flush stand. I had a 350 gallon tank on a raised floor. But, since the footprint is 8ftx4ft, the weight was only 109lbs per square foot. Or, less than my girlfriend standing in the room (don't tell her I said that.)