Improve workload list to work better with VS and other SDK bands

[marcpopMSFT]

• workload list should apply to other patch versions in the same feature band for VS workloads
• workload list should print message suggesting dotnet workload update --from-previous-sdk if no workloads are currently installed but they are installed in a previous feature band (See [NETSDKE2E]Workloads are not displayed in "dotnet workload list" after upgrade from NET8 preview 1 to NET8 preview 2 SDK. installer#15683)
• It's possible to get into a state today where dotnet workload list lists a set of workloads but the manifests have been updated ahead of the packs. We should investigate options for improving list to detect this situation (either do deeper look into the installation records or do a deeper check on the packs). We need to be careful this doesn't break the VS install logic as well.

[nagilson]

workload list should apply to other patch versions in the same feature band for VS workloads

If we don't need to spawn a new resolver, I think this would be resolved by the changes in: #30266