LCFS - backend filter logic on the Compliance Report index

[airinggov]

Describe the task
Update the backend filter logic on the Compliance Report index page to exclude reports in the Submitted status if there are more recent version reports further along in the chain.

Purpose
To ensure the Compliance Report index page only displays the most relevant reports, improving user clarity and preventing confusion caused by older, superseded reports being displayed.

Acceptance Criteria

• Modify the backend filter logic to check for reports in the Submitted status.
• Exclude any report in Submitted status that has a more recent version further along in the chain.
• Ensure the filter logic does not impact reports without newer versions.
• Verify that the Compliance Report index page accurately reflects the updated filtering logic.
• Conduct tests to confirm that older reports in the chain are properly excluded without introducing regressions.

Additional context

• This update is intended to streamline the display of compliance reports for users, prioritizing the most up-to-date and relevant information.
• Coordination with the frontend team may be required to validate any changes that affect the UI rendering.

[Grulin]

#1870 and #1873 need to be tested at the same time as this. Thanks!