MySQL returns the same result using the IN clause irrespective of the value used

[Deepthi Pullannagari]

The queries below returns the same row irrespective of the value given

select * from Test where Test_ID = (792718488739137399) ;

select * from Test where Test_ID = (792718488739137398) ;

select * from Test where Test_ID = (792718488739137397) ;

However when I enclose the values in single quotes like

select * from Test where Test_ID = ('792718488739137399') ;

Then I get the correct output as expected. The datatype for Test_ID is varchar . Could that be the reason why I need to enclose in single quotes ? Is it the default behaviour in Mysql ?