support get `next_not_cached_value` of a sequence by `select * from xx`

## Feature Request

currently , tidb can not get the next seq value from information_schema.sequence table.

**Describe the feature you'd like:**
support query next not cached value of a sequence.
like https://mariadb.com/kb/en/show-create-sequence/

**Describe alternatives you've considered:**

**Teachability, Documentation, Adoption, Migration Strategy:**