Partition key (Id in your case) must be in WHERE cause if not using indexes (but indexes should be used carefully, not like in case of relational DB's). Also, only columns which belong to primary key ( = partition key + clustering key) can be used in WHERE in such cases. That's why 2nd and 3rd are failing.
You might find this useful: http://cassandra.apache.org/
There are several Cassandra handbooks available on Amazon, maybe it would be helpful for you to use some of them as starting point to understand aspects of Cassandra data[query] modeling.
From: Behroz Sikander <firstname.lastname@example.org>
Sent: Thursday, March 1, 2018 2:36:28 PM
Subject: Cassandra filter with ordering query modelingHi,Regards,Behroz