What if a Product is in two collections and both the collections have different Tier price rules?

The Collection / Offer which is displayed on Top in “List of Offers” will be applied.

Then the next Offer / Collection that is in the list will be applied.