[BUG]: SERIAL type (postgress) is used in the libsql migrator script.

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.45.2

### What version of `drizzle-kit` are you using?

0.31.10

### Other packages

_No response_

### Describe the Bug

After creating the __drizzle_migrations table, the ID is NULL on running migrations.

This is because in the https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/libsql/migrator.ts migrator file, the ID is set as type `SERIAL` which is a Postgres type. libsql doesn't have `SERIAL`. Here's the issue:

```
CREATE TABLE IF NOT EXISTS ${sql.identifier(migrationsTable)} (
id SERIAL PRIMARY KEY,
hash text NOT NULL,
created_at numeric

```

Should instead be:

```
CREATE TABLE IF NOT EXISTS "__drizzle_migrations" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
hash TEXT NOT NULL,
created_at NUMERIC
```

Open drizzle-orm/src/libsql/migrator.ts and inspect the SQL that creates the __drizzle_migrations table. Reproduce a migration against libsql, then verify that the table assigns a non-NULL ID and that migrations complete successfully. Add or update the focused libsql migrator test if one exists, and run the relevant test suite.

Written by the indexing model from the issue text.