This is an automated cherry-pick of #46127

What problem does this PR solve?

Issue Number: close #46093

Problem Summary:

What is changed and how it works?

For a NONCLUSTERED table with AUTO_ID_CACHE=1, like the case in #46093,
there are both auto_increment_id and _tidb_rowid.

The model.TableInfo only get one field AutoIncID, the information is not enough to recover the table correctly.
So a AutoIncIDExtra field is added for that case. We can record _tidb_rowid in AutoIncIDExtra and recover the _tidb_rowid from it.

Check List

Tests

• Unit test
• Integration test
• Manual test (add detailed scripts or steps below)

Test the case follow the steps in #46093 manually.

I'm trying to add some test but find it difficult to do that in a unit test.
For example, I tried to add it in the tests/realtikvtest/brietest but found that it does not start the server layer so the auto id service does not run and I can't test the AUTO_ID_CACHE=1
I tried to add it in the server/tests where a server is started, but it use unistore and br recover table ... can not run with unistore.

 func TestIssue46093(t *testing.T) {
        ts := createTidbTestSuite(t)

        ts.RunTestsOnNewDB(t, nil, "br", func(dbt *testkit.DBTestKit) {
                dbt.MustExec("drop table if exists t")
                dbt.MustExec("create table t (a int primary key nonclustered auto_increment, b int) auto_id_cache = 1;")
                dbt.MustExec("insert into t (b) values (1), (2), (3);")
                rows := dbt.MustQuery("show table t next_row_id;")
                ts.CheckRows(t, rows, "br t _tidb_rowid 30001 _TIDB_ROWID",
                        "br t _tidb_rowid 4 AUTO_INCREMENT")
                dbt.MustExec("backup table t to 'local:///tmp/br';")
                dbt.MustExec("drop table t;")
                dbt.MustExec("restore table t from 'local:///tmp/br';")
                rows = dbt.MustQuery("show table t next_row_id;")
                ts.CheckRows(t, rows, "1 4001")
                dbt.MustExec("insert into t (b) values (4), (5), (6);")
                dbt.MustExec("insert into t (b) values (7), (8), (9);")
                rows = dbt.MustQuery("select * from t;")
                ts.CheckRows(t, rows, "1 1", "2 2", "3 3", "4004 7", "4005 8", "4006 9")
        })
}

• No code

Side effects

• Performance regression: Consumes more CPU
• Performance regression: Consumes more Memory
• Breaking backward compatibility

Documentation

• Affects user behaviors
• Contains syntax changes
• Contains variable changes
• Contains experimental features
• Changes MySQL compatibility

Release note

Please refer to Release Notes Language Style Guide to write a quality release note.

None