To find the row number of a particular text value, use the jQuery .index() method.

Search for a given element from among the matched elements

Assuming it's in the 4th row,

cy.contains('tr', ':contains(text-to-find)')
  .invoke('index')        // returns position among siblings (other <tr>)
  .should('eq', 5)