Is there some way a standard member can get a membership list with a sort by a custom profile field or similar?
For instance. If members are all part of regional physical clubs not associated with the website, can another member sort by physical club as answered in profile or would I need to use another method?

If so, what?

There's no (built in) way to sort by those fields, no.