adding cluster index other than primary key default cluster index
can we add cluster index on column (name) too?


No. Only one index is clustered. 

For MySQL: 


If primary key exists it is clustered. 
If no primary index but unique indexes exists then first unique index is clustered. 
If no unique indexes exists then the index by inner record number (hidden, unaccessable) is clustered one.