Already an issue on GitLab, cross-posting it here for visibility.
“When sorting, when the user chooses a “sort by” field that is of type single select, it would be very helpful if you could choose to sort the field by the user-chosen option order in the single select field. As it is now, the single select field can only be sorted alphabetically. However, this lacks intuitiveness. If the single select field options can be rearranged, then the user-chosen order of options is significant. Thus the user should be able to sort that field type by his chosen option order.”