[global sort] can not add index with global sort concurrency

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. enable global sort
2. add index for 2 tables concurrenty

2. What did you expect to see? (Required)

1. all running ddl jobs can use global sort add index

3. What did you see instead (Required)

1. only 1 ddl job can use ingest model and global sort
2. another add index job using txn merge

4. What is your TiDB version? (Required)

+-----------------------------------------------------------+
| tidb_version()                                            |
+-----------------------------------------------------------+
| Release Version: v7.5.0-alpha                             |
| Edition: Community                                        |
| Git Commit Hash: 79db4ec58be3856995d31013e20f3faa57e3a3ac |
| Git Branch: heads/refs/tags/v7.5.0-alpha                  |
| UTC Build Time: 2023-10-16 11:42:39                       |
| GoVersion: go1.21.3                                       |
| Race Enabled: false                                       |
| Check Table Before Drop: false                            |
| Store: tikv                                               |
+-----------------------------------------------------------+

[ywqzzy]

For resource control and limit the resource that global sort consumed, we only allow one job running at the same time.
We will support running multiple jobs later.

[Benjamin2037]

We will remove this limitation in later version

[tangenta]

TiDB cannot add index concurrently even after #48645.

[tangenta]

In order to cherry-pick v7.5.1, change to severity/major bug.