Add additional `ci_pipelines.project_id = ?` clause that change
the execution to use `index_ci_pipelines_on_project_id_and_id_desc`
instead of `ci_pipelines_pkey` which speeds up the query a lot.

Related to https://gitlab.com/gitlab-org/gitlab/issues/37745.