Ninja,Makefile: Restore Fortran module scanning in static library cycle

Since !8146 (merged) the Ninja and Makefile generators' module dependency scanning requires that scanning results from from linked targets is available before scanning the current target. In the case of a static library cycle, we cannot expect this information from other static libraries in the cycle. Previously we supported cyclic cases at the cost of silently ignoring missing information.

We already compute a global order of targets that respects all add_dependencies, but may break target_link_libraries dependencies that occur in a static library cycle. Use this order to filter the linked targets so we only expect scanning results to be available from those targets that build before the current target.

This approach is sufficient to support module dependency scanning in static library cycles as long as module dependencies do not cross between two libraries in the same cycle.

Fixes: #24631 (closed)
Backport: release