This is a very simple query, I suggest you should read a book on SQL.
You can try this:
SELECT [Scheme Id], RsStart, RsEnd, ProductId, ProductQty FROM tablename WHERE RsStart>='X' AND RsEnd<='X';
Where X is the given amount.
------------------------------------------------------------------------------
EDITED
Using select * is bad practice, so I've amended the script to explicitly name the columns. Apart from that, this snippet was good to go.
------------------------------------------------------------------------------