Add per-project pipeline id (Use `AtomicInternalId`)

What does this MR do?

• CE: Here

• EE: https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5745

• This MR adds per-project if for ci_pipelines

• This MR exposes the variable

• This MR uses AtomicInternalId (See https://gitlab.com/gitlab-org/gitlab-ce/issues/31114)

Are there points in the code the reviewer needs to double check?

Why was this MR needed?

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• API support added
• Tests added for this feature/bug
• Review
  • Has been reviewed by Backend
  • Has been reviewed by Database
• End-to-end tests pass (package-and-qa manual pipeline job)

What are the relevant issue numbers?

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/3691#note_69875536