Ensure id uniqueness on `p_ci_pipelines`

Before writing to multiple partitions on p_ci_pipelines we must ensure at the database level that users/developers can't generate duplicate ids. This was done on p_ci_builds using a trigger to always assign the id from the database sequence, even if it was provided by the application.