SELECT SQL_CALC_FOUND_ROWS * FROM websr_diamond_details WHERE 1  AND diamond_quantity = 1  AND supplier_id IN (2,4,5,7,8,9,10) AND diamond_type='lab' AND shape IN ("Round") AND final_price >= 656 AND final_price <= 1256 AND weight >= 1.06 AND weight <= 2.06 AND cut IN ("Excellent","Ideal") AND color IN ("D") AND clarity IN ("VVS1","VVS2") ORDER BY final_price ASC LIMIT 0,6