[SPARK-37322][TESTS] `run_scala_tests` should respect test module order
[SPARK-37322][TESTS] `run_scala_tests` should respect test module order

### What changes were proposed in this pull request?
This PR aims to make `run_scala_tests` respect test module order

### Why are the changes needed?
Currently the execution order is random.

### Does this PR introduce _any_ user-facing change?
No

### How was this patch tested?
Manually through the following and check if the catalyst module runs first.

```
$ SKIP_MIMA=1 SKIP_UNIDOC=1 ./dev/run-tests --parallelism 1 --modules "catalyst,hive-thriftserver"
```

Closes #34590 from williamhyun/order.

Authored-by: William Hyun <c824fe0afe16857dd6f587aa7c4044d2642d60fb@apache.org>
Signed-off-by: Dongjoon Hyun <6ff48b33cbb828151035af58a92f18a39f1d1036@apache.org>

zero323/spark,dongjoon-hyun/spark,gengliangwang/spark,gengliangwang/spark,zero323/spark,HyukjinKwon/spark,JoshRosen/spark,cloud-fan/spark,hvanhovell/spark,xuanyuanking/spark,rednaxelafx/apache-spark,cloud-fan/spark,vinodkc/spark,WeichenXu123/spark,apache/spark,apache/spark,ueshin/apache-spark,rednaxelafx/apache-spark,srowen/spark,nchammas/spark,WeichenXu123/spark,mahak/spark,srowen/spark,srowen/spark,holdenk/spark,holdenk/spark,wangyum/spark,HyukjinKwon/spark,HyukjinKwon/spark,nchammas/spark,hvanhovell/spark,JoshRosen/spark,ueshin/apache-spark,zzcclp/spark,wangyum/spark,vinodkc/spark,WeichenXu123/spark,srowen/spark,apache/spark,xuanyuanking/spark,mahak/spark,vinodkc/spark,shaneknapp/spark,zzcclp/spark,gengliangwang/spark,rednaxelafx/apache-spark,shaneknapp/spark,dongjoon-hyun/spark,WeichenXu123/spark,witgo/spark,gengliangwang/spark,shaneknapp/spark,JoshRosen/spark,zero323/spark,mahak/spark,HyukjinKwon/spark,hvanhovell/spark,hvanhovell/spark,mahak/spark,hvanhovell/spark,dongjoon-hyun/spark,srowen/spark,WeichenXu123/spark,zero323/spark,nchammas/spark,nchammas/spark,shaneknapp/spark,JoshRosen/spark,apache/spark,vinodkc/spark,zzcclp/spark,xuanyuanking/spark,rednaxelafx/apache-spark,srowen/spark,ueshin/apache-spark,zzcclp/spark,vinodkc/spark,ueshin/apache-spark,holdenk/spark,nchammas/spark,rednaxelafx/apache-spark,shaneknapp/spark,xuanyuanking/spark,vinodkc/spark,WeichenXu123/spark,xuanyuanking/spark,zzcclp/spark,mahak/spark,shaneknapp/spark,zero323/spark,dongjoon-hyun/spark,HyukjinKwon/spark,holdenk/spark,zero323/spark,xuanyuanking/spark,witgo/spark,vinodkc/spark,shaneknapp/spark,nchammas/spark,HyukjinKwon/spark,wangyum/spark,JoshRosen/spark,dongjoon-hyun/spark,cloud-fan/spark,dongjoon-hyun/spark,holdenk/spark,apache/spark,wangyum/spark,ueshin/apache-spark,mahak/spark,JoshRosen/spark,apache/spark,wangyum/spark,wangyum/spark,rednaxelafx/apache-spark,zzcclp/spark,cloud-fan/spark,dongjoon-hyun/spark,gengliangwang/spark,srowen/spark,cloud-fan/spark,gengliangwang/spark,witgo/spark,witgo/spark,witgo/spark,nchammas/spark,hvanhovell/spark,cloud-fan/spark,WeichenXu123/spark,rednaxelafx/apache-spark,holdenk/spark,hvanhovell/spark,zzcclp/spark,HyukjinKwon/spark,cloud-fan/spark,xuanyuanking/spark,mahak/spark,holdenk/spark,zero323/spark,witgo/spark,ueshin/apache-spark,JoshRosen/spark,wangyum/spark,apache/spark,gengliangwang/spark,ueshin/apache-spark,witgo/spark