What if a product is in two collections and both collections have different tier price rules?

The Collection with Offer which is displayed on Top in “List of Offers” will be applied. Then the next Collection Offer that is in the list will be applied.