Thanks for the update and documentation - wish there’s a better workaround but until “order of appearance” is listed among the various field options, seems like contorted workarounds like this is the only option.
You might submit this as a Product Suggestion section on the forum.