Add sequence to partitioned runner tables

What does this MR do and why?

This MR adds sequences to partitioned runner tables

Changelog: other

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

• Use `ensure_unique_id` in runner-related tables... (#523243 - closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.