Support shared `auto_increment` value across tables

Add support for a new type of `auto_increment` attribute that ensures values increment uniquely across multiple tables.

For example, consider the following tables:
```
CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT('shared-id-counter')
)

CREATE TABLE people (
id MEDIUMINT NOT NULL AUTO_INCREMENT('shared-id-counter')
)
```

The `animals` and `people` tables share the same scope for the ID auto_increment counter, so as rows are inserted, every ID should be unique and never reused across tables.