SOQL is not the same as SQL. In Salesforce, the SQL syntax you're employing is invalid. The Write SOQL Queries unit on Trailhead or the SOQL and SOSL Reference can teach you the basics of SOQL.
There is no support for a SELECT * wildcard in Salesforce until the Spring '21 release. All fields must be fully stated. You'll be able to use FIELDS(ALL) once your organisation has upgraded to Spring '21 (the rollout is still in progress as of this writing). Your question would then be something like this:
SELECT FIELDS(ALL) FROM Account WHERE Id IN ('123456789012345678')
you must be using API version 51.0 to connect to Salesforce in order to use this function. You may return up to 200 records.