Follow-up from "Resolve "Deployments->Environments displays wrong commit refs/tags""

The following discussion from !83558 (merged) should be addressed:

While fixing #341840 (closed) @bala.kumar noticed that the environment_id scope is lost in the ordering.

@shinya.maeda is worried there might be possible regressions similar to this if someone directly tries to preload last_deployment with an Environment

In addition to watching for errors once the fix is enabled, I'm creating this issue for the ongoing investigation into uses of last_deployment with `preload