> we had intentionally opted for MyISAM engine for some tables for better performance. Changing to InnoDB will hamper performance
That's an old wives tale. There are cases where one engine will outperform the other -- either way.
> SELECT ID
FROM TABLE_NAME
WHERE ID IN (15920,15921)
GROUP BY ID
The GROUP BY is unnecessary, unless ID is not UNIQUE. In that case, this would be more logical:
SELECT DISTINCT ID
FROM TABLE_NAME
WHERE ID IN (15920,15921)
If you want to discuss performance, then please provide the CREATE TABLE and the actual SELECTs. There are many subtle issue that impact performance, especially with respect to INDEXes. See
http://mysql.rjweb.org/doc.php/myisam2innodb