Mysql，从字段值和id值中选择行

Question

Here's the table:

  id  |  name
------+---------
  10  |  val1
   3  |  val1
   5  |  val1
   4  |  val2
   1  |  val2
   6  |  val3
   8  |  val3
   7  |  val3
   9  |  val3
   2  |  val4

The table is ordered by value column and I've to preserve this order

How can get all the rows after id=8 and name>val3 with this result?

  id  |  name
------+---------
   8  |  val3
   7  |  val3
   9  |  val3
   2  |  val4

I've tried with query like:

SELECT FORM table WHERE id>8 AND VALUE name>'val3' 

but obviously is not the result i looking for... any idea?

Edit 1:

Sorry but it isn't possible change the design of the db, and let me say that I think it's hard to say how a db is designed from a general table used to explain only a specific problem. However, yes i know the query is wrong but I need all the rows after value of the second column and FROM a certain id value... it's a bit more clear?

Edit 2:

When I say FROM a certain id value, i'm not talking about cardinal order of the id column, but i'm talking about the position after that with the id value specified

Edit 3:

Ok... I've a table ordered by name column, how can I select only last n rows? I can use eventually an id value (8 in this case) and a name value (val3 in this case)... i know it's unusual...

Edit 4:

Ok i've rewrite the question in a better way here this question is not usefull anymore please close it, thankyou for the time you've spent anyway

Answer 1

@mikeb in the comments is correct. Consider changing the design of your database.

If that's not an option and you only have this data. Plus your sample data is incorrect too. You want the value with id = 2 and id = 7 in your output however you say you want id>=8 (you said id>8 but I wonder why you wrote the row with id=9 in the sample output).

If you only want

How can get all the rows after id>=8 and value>val3 having with this result?

you can do something like this

SELECT id, name
FROM table 
WHERE  id>=8 AND  name IN ('val3','val4')