4.x: drop ScyllaRequirement in favor of BackendRequirement

[dkropachev]

Both CassandraRequirement and DseRequirement are going to be depricated and to be removed on next minor update. We need to do the same for ScyllaRequirement.