Ordering by last inserted row

[web master]

I have this schema

CREATE TABLE IF NOT EXISTS "blog" (
        blog_id INT,
        post_id INT,
        body TEXT,
        PRIMARY KEY (blog_id,post_id)
)WITH CLUSTERING ORDER BY (post_id DESC);

I want to get sorted list of blog_id by post_id , that means If I have
blog_id IN (1,2,3,4,5,6,7,8,9,10) sort them by post_id


I think the best way is a materialized view , but I don't know how to
implement it?