Run smoke/reliable tests automatically in Staging/Preprod/Canary/Prod MRs
Currently the jobs are manual in MRs in those projects. We should automatically run the smoke/reliable tests and keep the rest of the tests as manual jobs so that we can optionally run tests that aren't yet smoke/reliable tests (see https://gitlab.com/gitlab-org/quality/production/-/merge_requests/5#note_357723279 for an example).
When https://gitlab.com/gitlab-org/quality/team-tasks/-/issues/519 is complete the full suite of tests should run automatically in MRs.