[Feature] The multiple partition min-max predicate may lead to regression in partition filter

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

In https://github.com/apache/paimon/pull/1982 , it introduce the `MultiplePartitionPredicate` to use the min-max to filter partition. It may lead to regression in partition filter.

We can see the manifest file merge in the picture below. If the delete partition contains the latest partition(compaction) and the historical partition(drop partition), it will lead to a wide range scan for the manifest file, due to the min-max filter not works well


### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by reviewing MultiplePartitionPredicate and the manifest-file merge behavior introduced in pull request #1982. Reproduce the case where deleted partitions include both the latest compacted partition and a historical dropped partition, then verify that min-max filtering avoids a wide-range manifest scan without regressing partition filtering.

Written by the indexing model from the issue text.