feat: Expand Store interface; add GetLatestVersion method in Provider

[Albitko]

First pass at https://github.com/pressly/goose/issues/673

expand Store interface with method GetLatestVersion(ctx context.Context, db DBTxConn) (int64, error)

use it in Provider instead of an inefficient old one