create temporary table like table with shard_row_id_bits fail

## Bug Report
Create temporary table like table with shard_row_id_bits fails, however we want the ddl success.
We hope the ddl can remove shard_row_id_bits internally.

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

1. create a table with shard_row_id_bits
2. create temporary table like above table


### 2. What did you expect to see? (Required)
can create the temporary table normally, which can remove shard_row_bits automatically.

### 3. What did you see instead (Required)
create temporary table fails

### 4. What is your TiDB version? (Required)
v8.5.3

v8.5.3