Yep, although I'm not sure if clustering is also a hand-triggered process in SQL Server (like it is in e.g. PostgreSQL). In any case SQLite 4.x will do it automatically.
In SQL Server that's defined at table creation time.
In Oracle it's the same: defined at creation time, but you call it an Indexed Ordered Table (IOT).
In MySQL all InnoDB tables are clustered (in that sense) because that's the only storage strategy of InnoDB.
Isn't this basically the same concept as a clustered index in MS SQL Server?